# coding: utf-8
from . import db, BaseModel


class GroupGrade(db.Model):
    __tablename__ = 'group_grade'

    auto_id = db.Column(db.Integer, primary_key=True)
    evaluated_id = db.Column(db.BigInteger, index=True, info='评价人编号')
    experiment_id = db.Column(db.BigInteger, info='实验编号')
    group_id = db.Column(db.BigInteger, info='组号')
    evaluatee_id = db.Column(db.BigInteger, info='被评价学生编号')
    evaluator_id = db.Column(db.BigInteger, info='评价学生编号')
    evaluated_grade = db.Column(db.Integer, info='小组评价成绩')
    is_delete = db.Column(db.Integer, server_default=db.FetchedValue())
    update_time = db.Column(db.DateTime, server_default=db.FetchedValue())
    create_time = db.Column(db.DateTime, server_default=db.FetchedValue())
